Jeff Reisman
Jeff Reisman
-
Re: Formulas for Calculating Time
@Sherry_STS I just wrote this up for another community member last week. It's for overtime hours but no reason it won't work for start and stop times. I go through several different variations, inclu…1 · -
Re: CountIF for whole column Not just a range of rows
@Alison Laninger , When referencing an entire column in the same sheet, the format is [Column Name]:[Column Name]. How you create your formula for this count depends on your data. If the value you ar…2 · -
Re: How do you enter multi-line text in a cell other than using the text wrap feature?
@SmartSheet Newbie If you're just entering text manually into the field, use Alt-Enter, just like Excel. You still need text-wrap on though for the values to get stacked vertically. If you're using a…2 · -
Re: Help Extracting data sets that meet criteria to new sheet.
@Coen You can probably do this easiest with Workflow Automation. Create a new Workflow Automation task. Trigger: When rows are added, when Location is Hopkinton Run workflow: When triggered Action: C…1 · -
Re: How can I create a report that takes user input before the report is generated?
@Kurt Robohm it's kind of messy, but doable. First you need a sheet that's going to pull the values from your source sheet; this sheet will be the basis for the report. I'll refer to this as Lookup S…1 ·
